Configuring ODBC Client Data Sources on Linux and UNIX

For Linux/UNIX, an ODBC Administrator does not exist. This section describes how to configure the odbc.ini file and how to set some required environment variables to use the ODBC Client on Linux/UNIX.

Configuring System Information Files

To configure an ODBC data source for Linux/UNIX, you must edit the system information file, that is, the odbc.ini file (32-bit ODBC Client) or odbc64.ini file (64-bit ODBC Client) using the connect attributes described in "Connecting Using a Connection String". The system information file accepts only long names for attributes.

Example: odbc.ini for Solaris

The following code shows an example of an odbc.ini file for a 32-bit ODBC Client installed on a Solaris machine:

[ODBC Data Sources] 
SALESDB=DataDirect SequeLink 6.0 
[SALESDB] 
Driver=path_of_installdir/lib/ivslk22.so 
Description=DataDirect SequeLink 6.0 
Host= 
Port= 
UseLDAP=0 
DistinguishedName= 
Encrypted=0 
LoadBalancing=0 
AlternateServers= 
ConnectionRetryCount=0 
ConnectionRetryDelay=3 
[ODBC] 
Trace=0 
IANAAppCodePage=4 
TraceFile=odbctrace.out 
TraceDll=path_of_installdir/lib/odbctrac.so 
InstallDir=path_of_installdir 

where path_of_installdir is the path to the ODBC Client installation directory.

Example: odbc64.ini for Solaris

The following code shows an example of the odbc64.ini file for a 64-bit ODBC Client installed on a Solaris machine:

[ODBC Data Sources] 
SALESDB=DataDirect SequeLink 6.0 
[AccountingDB] 
Driver=path_of_installdir/lib64/ivslk22.so 
Description=DataDirect SequeLink 6.0 
Host= 
Port= 
UseLDAP=0 
DistinguishedName= 
Encrypted=0 
LoadBalancing=0 
AlternateServers= 
ConnectionRetryCount=0 
ConnectionRetryDelay=3 
[ODBC] 
Trace=0 
IANAAppCodePage=4 
TraceFile=odbctrace.out 
TraceDll=path_of_installdir/lib64/odbctrac.so 
InstallDir=path_of_installdir 

where path_of_installdir is the path to the ODBC Client installation directory.

Setting Environment Variables

You must set several environment variables for the ODBC Client on Linux and UNIX by executing a shell script located in the installation directory.

To execute the shell script:

If you are using the Bourne or Korn shell, type:
. sqlnk.sh (32-bit client)
. sqlnk64.sh (64-bit client)
If you are using the C shell, type:
source sqlnk.csh (32-bit client)
source sqlnk64.csh (64-bit client)

Executing this shell script sets the following environment variables:

ODBCINI	Specifies where the centralized odbc.ini or odbc64.ini file is located.
SQLNK_ODBC_HOME	Specifies the full path of the directory containing the ODBC Client shared libraries.

Executing this shell script also sets the appropriate library search environment variable (LD_LIBRARY_PATH on Solaris and Linux, SHLIB_PATH on HP-UX, or LIBPATH on AIX).

Using a Centralized System Information File

Because Linux and UNIX are multi-user environments, you may want to use a single centralized odbc.ini file controlled by a system administrator. To do this, set the ODBCINI environment variable to point to the fully qualified pathname of the centralized file.

For example:

In the Bourne or Korn shell, type:

ODBCINI=/opt/odbc/system_odbc.ini;export ODBCINI

In the C shell, type:

setenv ODBCINI /opt/odbc/system_odbc.ini

The odbc.ini file also require an [ODBC] section that includes the InstallDir keyword. The value of the InstallDir keyword must be the path to the directory that contains the /lib and /messages directories.

For example, if you choose the default installation directory for the 32-bit ODBC Client, the following line must be in the [ODBC] section of the odbc.ini file:

InstallDir=/usr/slodbc60